<?php
header('Content-Type:text/html;charset=utf-8');
?>
<html>
  <head>
    <title>点餐系统</title>
    <meta charset="UTF-8">
    <link rel="stylesheet" type="text/css" href="css/bootstrap.css">
    <script src="js/jquery-1.11.3.js"></script>
    <script src="js/bootstrap.js"></script>
  </head>
  <body>
    <?php include 'nav.php' ?>
    <div class="container">
      <div class="row">
        <div class="panel panel-primary">
          <div class="panel-heading">
            <span class="glyphicon glyphicon-th-list">&nbsp订单列表</span>
          </div>

          <table class="table table-bordered">
            <tr>
              <td>餐桌</td>
              <td>结账日期</td>
              <td>总金额</td>
            </tr>
            <?php
            $PDO=new PDO('mysql:dbname=diancan;charset=UTF8;','root');
            $sou=$PDO->prepare('select * from order2,canzhuo where order2.canzhuoid=canzhuo.id');
            $sou->execute();
            $c=$sou->fetchAll(PDO::FETCH_NAMED);
            foreach ($c as $ca => $cb) {?>
              <tr>
              <td><?php echo $cb['name'] ?></td>
              <td><?php echo $cb['DDJSSJ'] ?></td>
              <td><?php echo $cb['money'] ?></td>
            </tr>
            <?php }?>
          </table>
        </div>
      </div>
    </div>

    
    	
	
